SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431818 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431818 [ RunTime:0.004364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41453,576861,405738,466039,812643,352756,363330,649435,329587,668006,251526,98613,256744,222071,323541,155890,812114,134590,63572,796135,485281,572302,244335,41841,941249,336892,160103,1001830,722315,258969,1012675,411479,291503,322537,534016,995395,374342,882113,189729,66453,468968,960017,368126,1004266,741480,784810,444329,726334,351826,141870,1039637,249491,317674,251673,463320,469539,13798,3141,781000,420895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]