SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 212133 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 212133 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041783,1013840,626075,444745,783591,191571,862640,709344,282233,851874,536102,908120,699674,780880,161146,768611,429185,496110,22835,695422,585279,257421,389269,811974,673006,477859,818617,439332,46795,624957,317037,529945,862142,713093,353022,392530,866876,561252,835957,311011,350808,1003700,92260,914747,237515,341489,745695,585426,745479,830582,353783,468063,510570,261276,501403,396896,720360,606425,25355,996949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 212133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 212133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]