SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684014 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684014 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123878,154860,705390,496023,379596,368458,911411,479335,387766,520255,529918,127741,252184,620677,376025,1009710,2182,701698,595576,145062,735271,361545,25788,1026283,187306,875954,65377,220547,791712,903649,1033789,18242,272104,546999,732452,449765,278298,580967,682772,652370,930546,73977,320388,91202,761372,2868,663431,346853,800157,944864,74311,770259,507048,54891,371516,456788,758390,801741,357048,743939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003727s ]