SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550043 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550043 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95456,551982,408642,542287,534719,829849,576209,278078,1038453,225807,42744,116565,525219,804433,781739,848502,10589,759848,423153,388780,547598,787586,428136,229189,132787,831333,191031,139826,991087,953830,677508,527929,124841,535060,294761,982377,751093,958573,957872,34512,345574,187600,99966,523380,464012,746913,756624,510539,447791,883764,291646,587780,564641,252288,652498,909338,420512,476274,66463,198321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]