SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424851 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424851 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042287,910781,231093,1033310,539666,228352,82964,288730,989831,959043,966133,787023,497255,575444,804591,697164,80417,254208,389216,912567,8639,247570,269804,919166,1015163,428743,409927,985162,881908,573830,165829,1029955,660531,1023170,190938,621499,357279,803265,951917,467676,420563,195293,231107,348733,309582,180542,54957,244840,1013566,362235,158553,146168,548266,336599,550576,489137,91151,975889,824222,386170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001499s ]