SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554926 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554926 [ RunTime:0.002515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298815,1047437,194771,863501,1000448,220117,600413,684574,209890,814268,583911,1002643,205337,102486,538605,551628,964345,757138,256108,789881,371637,1018686,309551,133345,128229,912291,488467,58383,268370,932454,372609,489198,922306,30014,320114,727577,559310,129365,914581,1036013,451413,837928,783679,400277,199601,846980,657601,390425,97389,549658,158211,669780,147368,167787,805496,132210,913484,4741,419178,810867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]