SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512936 LIMIT 1 [ RunTime:0.000934s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512936 [ RunTime:0.001432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021486,998006,306087,643487,794038,699674,933140,767068,413951,77462,69679,555336,814049,271750,465656,789758,835749,266971,464001,565370,164822,400340,208262,545607,59380,163246,384961,930060,13886,763852,171772,529229,390403,44820,496070,108337,555132,355389,75509,130814,943818,923421,300048,1013070,863632,777428,329006,31845,299840,435647,909737,250938,1046021,279463,683074,428332,694972,25587,686328,994104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]