SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523180 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523180 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744041,868097,994927,1001010,979684,536599,966578,912370,274665,290533,147734,1524,45635,939560,539823,85089,925122,240674,1777,806874,683248,199269,156958,472876,551527,835345,394488,990051,1021385,292072,268177,642714,722059,610057,237648,55405,1039531,597706,470037,930665,563023,162563,366226,159189,98307,74387,342562,970681,12633,49322,472914,500086,80108,31060,665679,150324,559223,449368,91103,877605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]