SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001954s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042062 LIMIT 1 [ RunTime:0.003396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042062 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354996,58482,582775,900346,542263,227265,790674,1002690,831383,1032727,783465,777455,861861,117026,794993,817407,480404,956848,52125,798192,132595,637715,156756,189256,221212,510023,164825,982274,850599,273691,953484,743344,72162,505938,104618,740506,116777,35058,503897,323880,254312,550228,339822,444075,607447,878985,275419,846797,9390,253497,563930,982957,779160,775838,607369,503265,277568,779142,681350,788921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]