SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535524 LIMIT 1 [ RunTime:0.003751s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535524 [ RunTime:0.006073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329469,659041,23204,667971,414841,942159,748001,1009895,725515,820982,525148,274731,950601,297893,722394,229277,128665,983859,458366,367388,806617,105779,210592,562128,689297,462063,202927,65977,1014181,773346,497237,563544,810714,379231,874198,401236,781370,876269,870481,599518,623619,804246,517475,874192,245216,249523,845557,45798,729782,252050,784034,100369,708300,970541,842085,638362,777031,704599,555296,487020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001575s ]