SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506830 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506830 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63946,743326,186678,298036,625040,900803,712651,491221,528608,879049,174541,807605,269184,482273,764695,379540,425178,227974,722689,235022,816888,58790,959494,347607,194842,249834,70754,836444,632998,536170,242022,203337,392448,806995,935429,551536,76619,1010688,369883,412321,30127,514417,613084,149184,27240,983748,986967,304620,229885,965799,438007,309082,843188,725279,659837,43680,754281,862748,923120,591909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]