SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536714 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536714 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583132,557203,315293,206948,476876,534797,628209,1019168,190245,798921,834749,148289,354747,817052,727187,1038474,985732,574409,644890,142297,998704,311765,1007509,891367,578215,735896,904865,141471,75549,861662,191616,178732,64449,431648,938394,716135,733373,787533,30751,1024695,92115,947224,81470,135979,1592,585165,883917,990912,111003,871610,461204,878167,550191,596499,964239,230464,1040939,789352,471579,184459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]