SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54523 LIMIT 1 [ RunTime:0.001198s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54523 [ RunTime:0.003977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000750,368767,311341,950426,915091,553927,623433,445226,281449,19681,474008,402716,858328,39572,519969,651207,199370,389596,614115,29882,794251,67693,836421,108283,120161,92465,629598,1036780,809411,342707,159490,752003,1007300,858224,230864,756755,283174,644690,126944,18604,68081,283503,393895,436845,178964,421061,905692,564191,961654,765989,60752,575912,1038644,338710,249385,502811,286433,303349,706148,892909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001336s ]