SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340909 LIMIT 1 [ RunTime:0.004391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340909 [ RunTime:0.001325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755030,990912,1012104,6580,340775,155015,918557,745426,189077,1001104,235429,125526,388981,865766,591301,457321,656602,347887,507437,436803,585560,427771,802969,521214,795797,88535,1037102,343782,747500,278370,167542,33426,360658,44615,784826,489161,604446,1021212,956500,484472,341811,135317,573992,838278,309991,968220,27578,389556,244123,823639,50482,277203,527275,858961,41248,979761,295437,443838,801171,647259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]