SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003666s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410429 LIMIT 1 [ RunTime:0.000796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410429 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18342,195859,82321,884326,691491,678546,304700,414479,45126,355749,64463,318934,510462,552721,899785,727071,896893,848518,454334,728934,984139,98702,661902,207429,262067,915943,260286,814828,988934,63320,83250,288112,940577,698110,962233,730507,7221,361898,979016,889188,280616,1023863,221228,634840,583916,203431,935172,284773,539739,73876,773858,780556,464103,846095,561211,790300,968810,824321,565611,677386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]