SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502201 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502201 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53151,605596,424696,287441,160038,390627,617690,281792,867627,160828,614079,86533,631050,873958,203302,93965,232199,342545,368980,700469,213947,414812,495595,865361,415062,392638,726663,512569,524056,186468,887307,455687,524500,909059,442039,165095,804918,439890,430606,598867,487568,1012057,598971,82115,1002577,204670,870297,391435,696133,801376,669348,305462,307609,1032101,691683,190685,210267,1029870,163586,213659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]