SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406688 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406688 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901418,406427,745748,680618,928840,534592,326805,1039644,871279,491624,326814,657335,1048178,533986,120307,913704,54035,624696,949589,834982,772412,98826,877026,837359,293109,720650,493468,748229,519893,283894,707974,826398,471695,1863,965157,21705,287592,844258,427123,555285,938009,622890,374225,273471,528519,44784,943369,203543,250224,720619,437728,838335,1021228,475115,1022436,1029541,84083,362332,335372,297821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]