SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427341 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427341 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548715,976380,122376,415386,11603,815973,349580,147586,473199,162241,923948,825364,844960,989018,1000490,216056,84502,94863,900431,474081,1006145,992195,401867,467311,613583,423885,608081,76789,372292,359045,566657,323312,166213,123062,851738,478357,749085,511748,761997,330433,951489,137918,351633,271758,582285,1037556,292660,30393,287707,356887,876503,819181,19168,121975,762808,453160,98065,439534,132848,370816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001456s ]