SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40119 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40119 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158023,338766,321882,846911,674881,903011,506505,831256,14659,162633,523983,951710,700936,63995,781560,194385,407268,170049,166141,889948,615415,225103,520829,312148,910734,427506,843422,158702,207647,188785,692506,27695,1034962,235062,176788,1047771,170240,1029435,90966,391046,850649,789185,517365,674729,310144,882884,453472,420248,774528,542658,234586,557946,650592,687646,682690,1016508,31775,996688,165669,732718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]