SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 78172 LIMIT 1 [ RunTime:0.001018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 78172 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203684,951916,309444,662711,413025,931048,727668,533141,931180,813839,1015867,581074,678521,716792,1041310,716500,773338,118168,758652,408406,567839,797444,771867,665921,266981,132223,155318,600315,114625,234301,950704,457007,984950,218474,153717,640214,305977,170714,870838,478773,463508,223764,456535,786396,510361,425482,39591,717786,46231,769561,575055,830990,360386,312044,337716,183214,35794,204858,681708,825746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 78172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 78172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]