SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515498 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515498 [ RunTime:0.001466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704661,352489,87776,818313,412182,231907,1002746,262019,964123,429593,423663,368102,633803,5351,323677,913220,884415,836347,567851,908217,448048,191108,20772,335323,794034,272026,834397,811095,133114,422700,191270,221342,766186,358795,120910,35217,96036,910577,816554,370700,349222,447941,196003,323513,776230,526721,12275,457879,906824,894042,921168,446523,79373,974101,695057,980501,1023509,336308,651477,851945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]