SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205380 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205380 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449779,691182,962659,746131,508316,560857,79437,692462,602343,100211,363189,590478,1040632,165286,381704,44008,462856,977235,528131,5403,110372,912147,359010,490449,834952,26478,803330,149784,855734,855272,72177,644886,693014,245238,762646,217772,405901,860334,132215,682915,195333,78510,323586,458890,362965,920955,455027,609624,798497,74497,332611,622977,698476,566279,56229,1016859,113836,505908,935170,18024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001507s ]