SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48896 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48896 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835744,104667,364864,128507,632946,944051,503034,650457,672606,589930,1048094,981020,227912,705959,509171,356582,435576,473853,239670,206198,871748,500128,388771,519190,566954,407203,761484,1039375,336935,398134,400245,196282,394863,611888,123112,986777,718636,302053,545595,580160,771658,415812,474909,849777,955109,981149,302787,254997,366602,104334,1045840,511981,665413,595177,307395,509187,819096,535243,879674,462305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]