SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204160 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204160 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924041,15835,97142,136475,550866,321501,609039,429523,49955,234626,617878,17075,973451,965569,266342,216699,342984,159120,262807,592630,140566,694273,733542,937813,734909,851661,25279,813838,317884,153560,618669,916798,991124,496783,745295,43488,7881,451580,754819,265477,844626,1024324,1035713,100867,570899,936448,732856,328318,363662,70867,152460,611285,644387,81019,428132,1037725,1499,86700,840251,474526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]