SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385314 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385314 [ RunTime:0.002561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851772,421994,965090,278284,347969,996253,66277,920781,214994,662794,715006,315623,746972,642862,73995,1013073,921551,785781,616404,887480,162904,274766,531005,621907,785241,254335,1023280,254522,855524,138658,910147,87177,738014,582222,424143,464206,116968,973506,818204,116471,454285,435843,734914,820084,815970,336461,821626,167787,409629,731037,971246,191524,335468,431153,947381,397135,276771,27135,834149,155644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]