SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018163 LIMIT 1 [ RunTime:0.001830s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018163 [ RunTime:0.001210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515963,124134,341910,360092,740537,415913,182429,955531,932670,928919,894646,257791,354177,151052,536972,167570,75383,165993,17048,849939,622675,90618,586129,814400,513694,484007,300381,91103,452024,890450,315290,651605,276468,821664,505936,562368,627664,777142,133561,213719,610791,136810,286400,685043,860600,813673,555586,655791,834550,252023,166318,868870,405304,444822,460169,300102,282822,974840,1037565,744392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]