SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412024 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412024 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805871,457152,704024,810215,840443,224956,787735,494601,261110,1510,782672,603481,278126,578461,34561,767521,639461,805031,878050,365278,106826,85668,397443,618565,546252,912383,127657,614513,723111,283193,366590,671596,197514,727360,14298,140993,514568,713398,139916,899862,244585,869843,924739,69604,812094,1003772,20044,313690,4579,544119,461436,165118,279695,1024264,285825,3614,555275,502291,356682,580234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]