SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570710 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570710 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356947,654489,368477,458668,412091,158182,572945,649271,898266,940706,159543,166718,426318,372243,379261,926501,927429,685030,484185,903899,777717,211426,389779,211080,173267,1033809,612211,450419,739159,812270,840264,436734,143711,524193,111332,701127,299732,442105,585334,603860,894011,182042,116360,778560,689691,529207,205990,208866,437003,159632,182032,894759,45102,846879,337150,964527,872162,892421,87540,234444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002166s ]