SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006236 LIMIT 1 [ RunTime:0.001270s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006236 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410925,797433,935486,864556,1029120,388302,593107,892743,985734,946790,957070,371212,898105,1010256,18372,354579,115110,921730,735183,1026887,984527,899171,843634,496078,750725,1021553,921922,968876,979472,509107,865418,940495,128642,501137,912887,579338,875167,745691,865374,751597,659892,699226,495445,350180,430180,635127,824868,698454,305777,455057,602589,959467,664196,575567,36968,652342,913922,761874,449988,269299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]