SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509096 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509096 [ RunTime:0.003750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671224,309216,305426,921856,119560,213799,587678,328888,263948,103128,9165,146068,1000401,425133,137422,16296,388390,408296,764563,302594,90828,542569,983511,965817,892397,250804,108564,475255,472044,1014996,953331,953827,893095,620504,35583,127419,340724,269596,212890,794247,962587,935116,604602,731719,831761,954943,450396,4449,635970,224243,946584,104199,824025,397200,655290,605194,794479,118836,703679,615466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]