SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354875 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354875 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621701,167669,913533,31874,796640,775337,940330,499670,864388,334870,452911,301620,893355,501670,317038,560537,177179,128995,154168,987318,931164,483942,763781,473628,256830,888789,312180,72566,965092,276194,1048174,23227,921729,533595,328439,985757,240406,38752,655959,44282,451172,1041643,755269,789187,200153,197342,968459,145259,150989,152504,530317,924179,414219,915339,694000,210296,579330,18288,942390,254599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]