SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586935 LIMIT 1 [ RunTime:0.001065s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586935 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351562,765693,317168,426395,402103,376687,971027,46286,1012041,251953,978664,13952,691074,549426,97070,108282,518225,822015,1023661,153924,825041,724761,474823,643765,65193,723227,557356,886876,344869,79884,385795,873993,979735,655641,828706,50167,387250,605560,36030,619691,860892,121750,230921,229366,660623,775989,956274,1025779,867,454890,1016396,602765,216528,424222,560693,1010389,957028,316074,788109,486379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]