SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488161 LIMIT 1 [ RunTime:0.003063s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488161 [ RunTime:0.007935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280920,65101,235364,980490,169785,791944,916435,726872,413725,599981,701288,793478,889200,829688,405826,529189,832256,711316,940951,505115,283870,421304,708068,331994,785365,982603,959134,1045524,489281,264491,414714,484363,196076,179767,919184,365190,671780,72270,428951,714316,536476,271299,1043898,25221,984270,38514,718562,105274,111004,913263,566134,542806,36936,555331,169838,575216,102758,564545,531031,690383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004628s ]