SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314413 LIMIT 1 [ RunTime:0.000654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314413 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542548,760163,868443,962673,658817,559144,131739,740100,1026161,672267,788702,987803,504073,18721,843592,879625,385144,473373,598871,886173,870997,486561,456817,844273,20487,94671,596084,511913,629694,541571,632105,108180,547124,269247,411933,20785,333677,546138,669109,36708,690307,875391,450277,253506,999177,879069,685996,718899,563365,1030264,1019814,362157,255376,702445,635405,528471,813545,756625,631515,562525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]