SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262287 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262287 [ RunTime:0.002334s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111161,749672,900113,113110,1047996,180480,564258,534101,383626,857919,1042945,331669,871264,278855,99101,12627,668628,79819,976014,1006866,1005212,429768,465059,160266,975916,745996,937821,805317,91843,947840,739361,334364,189279,89489,938371,469691,538007,292351,227352,889505,133531,201512,571680,891213,496659,790593,1002846,208935,43206,923706,523332,157119,36789,498066,271756,583813,142893,603949,1000922,168566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]