SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559028 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559028 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385130,642275,788096,283672,708397,497744,192224,928999,61686,457977,288199,730815,1046162,660757,523230,1045873,843034,1032578,349881,967690,676623,383458,259090,556094,510509,883566,447469,916547,252588,332275,900330,547654,438895,634005,814665,642812,871948,550348,705105,32179,86933,663273,218300,712224,525255,229016,540225,394283,665508,212801,839095,547772,43550,706725,45535,540118,962070,849689,622382,58740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003241s ]