SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 259494 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 259494 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332782,741827,967383,813135,221835,1002527,249580,830090,750475,2809,995259,590522,968577,949586,889154,620518,26509,65276,383543,194596,747161,379875,672049,126746,220259,118746,627523,264273,818958,241878,762755,299257,379360,1025772,380217,970885,4740,615736,796798,9612,285585,402340,114214,218897,160927,810054,907209,385073,3105,888560,261795,6268,257898,819712,485941,345585,291091,3765,965343,810203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 259494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 259494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]