SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031761 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031761 [ RunTime:0.002600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160048,49042,304918,200221,708883,7413,57458,837454,707608,185628,794494,450550,304356,631987,81910,527091,675996,147628,479591,1023165,753835,880658,818690,610753,195806,485966,225579,1039743,884963,662829,733871,128495,914977,448434,263799,132724,840747,255102,575448,841217,559226,204247,603593,591827,422819,742477,323649,989023,1046882,331878,477579,1030305,82249,963790,636306,450392,112127,569083,811907,79029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]