SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534443 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534443 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130351,95784,544592,653207,827757,897013,975891,409028,954990,324728,823204,58255,296805,255690,565600,850874,498196,616218,416637,189637,638370,773993,906317,134038,981541,799145,1026134,1006138,337963,358956,266641,662888,496718,565037,114883,633225,340863,543216,1138,402938,831475,168510,850995,981969,848646,212788,940199,642252,139686,631356,899590,577469,558008,199254,406096,174334,338147,802871,945709,940745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]