SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505358 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505358 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139928,202119,455870,488002,934053,495009,832847,151284,716503,631703,670392,860085,251268,989024,691032,256196,437272,191040,695756,611568,739769,224060,332926,406418,675184,730491,960860,775587,618167,223757,520425,834738,556410,421778,928016,584533,69483,1000722,477239,201670,608872,832555,405812,545267,530986,141535,546153,475222,850576,820007,884420,326823,808959,152115,41825,35014,659364,367181,918860,853138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]