SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502481 LIMIT 1 [ RunTime:0.000690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502481 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402912,226062,433355,652733,190473,183980,110976,848028,592939,360538,323179,914742,764420,772525,907531,8160,61272,129757,139533,246526,738371,425178,967258,504588,509544,178059,1043058,475228,442899,316969,312799,891570,389899,28731,737176,298885,460434,696564,1014843,793881,72939,642834,197486,44822,176251,835922,22546,874621,399262,958619,396407,497752,669027,750724,946264,911373,557259,602978,263609,702456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]