SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047455 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047455 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876675,375937,901217,1023295,560274,903053,890631,518594,933620,392976,649924,932465,719023,961327,120953,692230,6680,930845,218525,775575,938210,1023629,810660,673840,720550,733017,282405,201460,208623,363038,630979,198739,1021798,623869,869360,356022,546322,628953,413715,415017,355836,90668,12460,679610,938187,1039618,289893,801705,1044448,730378,405944,911895,751063,977479,555553,512402,119162,617282,176544,13807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]