SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538585 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538585 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846858,20075,709497,151011,450512,189381,1039658,673965,74978,537751,119074,419805,65410,958514,462180,904416,520074,921589,111001,313903,608121,677026,645564,193955,662762,1032058,208414,521202,392132,49203,101235,727132,1018180,455597,507308,708709,1040784,56335,645772,633568,614753,112516,87769,608647,855656,903025,595847,304680,560831,134502,467864,428171,988638,20576,770432,17551,1016758,90956,355490,981577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]