SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015136 LIMIT 1 [ RunTime:0.004009s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015136 [ RunTime:0.004876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200528,484482,687478,256278,535055,64653,100841,135801,974769,426085,501438,35930,3396,629869,892252,511581,991355,786882,591817,628073,262170,341317,964562,849417,151631,158647,278120,153862,415009,787472,416994,580657,964961,159316,96327,961697,229463,849804,111954,526048,455339,797441,364454,216438,712582,144394,574577,101168,89241,804439,653105,683514,430040,740587,717646,977154,328484,540530,557991,1011047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]