SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517238 LIMIT 1 [ RunTime:0.000859s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517238 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72791,912140,86780,79839,818925,608544,995095,713118,9873,799750,881521,996486,246150,244612,393450,834727,800820,513498,676129,902854,558926,406755,431294,875134,189064,398218,499133,764330,509022,991054,356331,359248,269132,969534,202584,215849,871014,122905,95282,44829,650479,1035850,653853,412763,534500,937169,677349,632486,645943,310945,972603,809950,4217,384615,436785,71809,408244,1036678,1008044,368116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]