SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368207 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368207 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728220,895964,199096,1017234,995628,303698,105452,931735,741079,541935,829562,595441,158981,18001,768366,911048,509757,126471,132264,555935,877522,749715,93130,440399,796609,902118,113564,385241,573,1044298,613878,536906,463468,1022377,1005880,320051,87775,307680,990010,647280,995863,34243,317235,558475,223751,128382,73839,696849,766862,488732,226553,309471,754828,739159,509040,289869,517578,335606,85833,700331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000788s ]