SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442531 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442531 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985609,666669,312803,1021567,881048,991809,396085,316579,218500,247649,153097,903756,424843,724782,878959,491303,661120,447602,12045,831678,402193,384968,428603,812860,347183,454676,818199,872485,1022069,775455,298790,587307,167435,1044069,503562,230485,175008,608453,824059,889174,859753,166776,817863,56806,846226,193846,967773,711794,1030747,337304,491963,906062,436967,258374,466157,992562,195025,619014,312252,724551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001736s ]