SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291910 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291910 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73991,700186,133624,716021,148612,345944,1038550,148807,514442,396464,686016,578232,642160,285103,532615,534995,348995,720595,55209,430421,740671,522184,122177,493222,377737,837104,492379,373778,230019,423850,311543,357277,727919,377963,663660,8737,987988,780863,945758,811439,439928,360589,734195,1026404,910606,683079,716429,166606,911807,711390,135007,67531,983929,819862,136478,969873,1031550,581726,540135,91463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]