SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382208 LIMIT 1 [ RunTime:0.000872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382208 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314945,810478,534403,9621,135114,441297,227654,600722,168866,186203,928638,11039,59435,611578,632456,795009,925938,853429,916578,952600,114355,90597,718545,671155,352403,458658,995507,945652,303696,905515,783693,911897,3528,507972,265861,758309,385432,921930,598530,634572,524633,900478,812295,83261,580347,473533,249777,161120,964698,934828,693943,518413,831439,564169,108100,968078,584960,985058,430002,39402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000936s ]