SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002929s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 641021 LIMIT 1 [ RunTime:0.001191s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 641021 [ RunTime:0.005325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982972,192123,195994,821173,530691,711300,629381,466591,131566,248883,768300,293338,615059,312064,752906,13986,290197,255386,1042937,123046,1019981,873929,62815,107223,472525,100618,500805,586141,312219,794236,90122,977889,505611,898675,844259,680331,561410,120771,946889,108433,983712,102578,639943,169634,783761,945784,784005,688222,338779,916978,746217,668275,581884,510412,959144,1000974,476715,310842,221990,530268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 641021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 641021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]