SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340554 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340554 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169143,21648,398622,418950,589794,384113,30511,271639,64088,736800,836649,556627,68854,610211,666528,513527,497949,541202,1048430,703583,1047495,524677,590400,601779,711043,551359,136966,546356,789509,86372,1021998,540763,565464,537797,600814,23065,988049,439068,246485,749022,760249,752095,865653,460136,282005,529689,108932,787825,936083,986366,914392,787804,708643,602675,374547,861395,356509,477618,620754,697656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]