SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53121 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53121 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669182,975695,434259,231014,783944,170893,571126,550366,269018,809399,222220,14348,738,544035,57244,139320,453201,508257,1022370,543151,971068,84023,721088,249941,1027710,59917,71038,165961,219585,941848,203976,968650,77638,970104,925003,63405,6270,820011,610633,392362,382570,254010,256019,840571,767642,912359,146180,178449,289572,962045,724982,698062,919881,926895,673875,704379,105662,718171,941293,947108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]