SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289881 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289881 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261234,748745,658680,436525,771267,301663,527586,556887,383756,1005448,1028113,390124,939299,56466,113048,317477,643072,921560,21576,735577,272781,388715,317063,97578,669389,471386,839514,512286,738440,794213,187500,1041749,415667,588569,223002,639969,847555,363202,153198,93252,20692,933636,765209,109738,33588,295797,404545,275837,640148,988927,1034374,641299,227373,384260,351848,279514,854400,941233,883157,1040636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]