SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59104 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59104 [ RunTime:0.002363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684894,136718,145991,961274,403835,177244,911457,673683,700946,921809,666049,897264,864620,535330,498806,191779,852790,703088,115178,872959,995685,890971,284241,256158,381536,231052,179110,676725,108837,399214,983232,1015965,384187,894156,490652,702876,814609,362715,802121,11949,658959,605623,345780,673298,844636,1009776,74662,52958,679367,252395,547606,360360,808640,721831,383983,708811,1002280,582360,41598,490576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]