SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200507 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200507 [ RunTime:0.002929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736678,837128,677253,881563,130869,349589,851024,593278,857258,590543,795388,318693,405481,730579,238952,248540,1017802,931199,661632,248788,699229,86445,349141,424442,548430,49980,154970,671056,829415,358779,1020899,120783,1000735,38285,525405,675797,124909,96179,210928,875976,550841,184599,68223,250810,389167,343095,459721,142444,324639,661250,153050,134030,350715,122406,795760,73674,455484,1045312,412847,795637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]