SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516447 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516447 [ RunTime:0.001455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916626,788491,643659,482461,5946,811539,20349,596248,864789,75780,119078,641509,324867,403551,141464,645091,364507,370712,996361,851710,39516,274943,408267,74062,183713,91143,947836,473590,606061,471852,47723,52434,396295,165553,744261,864828,552299,723419,895125,761380,769109,326135,827963,622549,1005631,822911,113127,274935,353573,372776,902560,811972,205254,178411,825831,94088,802732,365234,912501,663417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]