SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101060 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101060 [ RunTime:0.002529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436889,461387,814016,982619,879631,310702,341215,723998,564592,176151,774597,651986,697643,752388,948412,46960,924082,306050,1015511,353788,673326,173605,126623,74856,872319,172064,329704,945541,161822,219230,138005,163722,705744,856400,725776,352492,37433,401191,338662,251862,292196,432499,515984,812296,331069,630515,159796,262694,336467,168083,848623,187294,453295,585476,928685,1034285,578255,318264,959031,931084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]