SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566160 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566160 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429106,635086,323159,497488,496287,485431,983157,648868,348752,534636,1010750,600419,130940,425133,706217,128326,95026,854971,980867,259549,265162,352492,267367,28452,67417,1046469,41209,409946,660987,388452,580267,171221,143079,99783,453203,785154,1048662,604381,1025811,18127,891421,314278,863522,979706,442378,43134,674972,1045739,639511,209719,811876,345735,92103,277288,730570,301220,776827,171486,731875,835134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]