SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354393 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354393 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694975,278186,985401,665428,280735,189933,728925,151767,358438,361971,815032,628476,244502,86272,586075,414932,1016543,193533,880734,441835,367807,585405,868215,248673,240886,955451,21466,1029774,774325,765295,410399,139660,647008,637331,1026481,769263,972249,554752,235633,267169,717390,750510,702543,693250,92157,315222,4082,542150,8973,192820,560741,92290,3673,969075,542565,976851,650515,675907,364312,124581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]