SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002047s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428830 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428830 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355345,569643,594568,250833,691325,44989,175163,188240,616643,517316,16488,145233,186474,560558,366621,906277,51238,387878,395612,237634,650905,280645,795365,540539,364800,997985,649896,339128,100116,812417,115798,465510,1016368,653023,172796,782283,261051,931574,371825,586139,259053,980724,438524,634284,574174,304819,6208,647571,592443,541521,602454,866084,993732,379604,954408,2473,853085,960895,84839,247851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]