SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356071 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356071 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803487,1014401,777332,940239,135215,163111,684070,966337,189638,490727,648498,371265,642752,16710,803558,435320,83987,119424,820310,595288,600537,565075,490170,943336,118262,819198,910607,325044,503886,787860,84038,86869,598972,397468,118882,455485,674752,380170,439175,958116,643605,413184,279960,152149,332408,754635,104659,66275,672611,525670,592879,1013833,968728,114777,494011,266546,388523,794917,886592,398677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003296s ]