SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010885 LIMIT 1 [ RunTime:0.002410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010885 [ RunTime:0.003609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904084,161823,754294,220233,694896,635925,551514,819558,820709,643000,868226,474421,967639,654308,487106,521718,450113,164310,621495,57867,483887,889280,883111,570060,483143,816088,112658,521800,989788,685965,191215,57371,408858,58324,266151,928126,296903,124679,143543,979570,791851,744898,778453,363252,493510,685874,82067,806235,102087,58911,492411,349914,518586,939146,632683,225777,249723,72770,128628,484695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010885 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010885 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001051s ]