SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019013 LIMIT 1 [ RunTime:0.000860s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019013 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585379,956908,328200,873672,991724,461560,823315,799394,899998,803945,575603,23243,109501,312286,432827,231717,268394,502890,6787,698650,248812,953627,75383,602026,815236,938622,1037714,633963,94780,557653,715366,699319,372273,568587,234331,891640,983935,174152,863024,376368,925759,564140,797510,312423,679342,494969,714487,1008218,9148,90361,472572,75806,737431,181280,476789,503854,806732,765810,720422,378324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]