SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029106 LIMIT 1 [ RunTime:0.002175s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029106 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961165,208905,829556,276486,459794,752201,1022950,131403,975781,332747,717673,1008106,40783,891101,54457,222545,45287,318047,592845,688749,33099,439041,201365,706409,858947,306561,145760,579025,87134,741492,896329,450222,548794,449760,369728,479538,214111,803451,303621,727693,148209,879339,98217,846909,716140,99187,750072,613253,634386,27219,739422,717016,870723,578112,359243,18698,25298,957635,843914,932365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001333s ]