SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332518 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332518 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98646,842171,976507,61801,509058,507798,212235,960945,382678,70255,704669,837937,935722,643965,809308,202613,515622,969879,16883,124842,848115,596548,30343,952343,18494,888461,389290,93574,55431,452932,82201,854757,1031017,470860,975064,417163,219792,588679,435758,539397,214448,128697,593743,1020643,1007851,424282,691301,901061,647108,649095,28285,296505,826612,184920,358516,356574,604,991040,804411,554111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]