SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20106 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20106 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848163,726687,392884,206447,452013,24838,188666,102021,764422,19202,265701,400506,957737,139204,910053,809822,421879,62305,71745,916087,284456,757264,80834,968095,1028607,322554,269385,391912,782721,24301,176326,879926,96106,447743,394689,532855,793783,440851,303905,155057,871856,163778,1025063,463074,961047,889711,1029708,955861,584038,488709,448147,323376,613936,763736,490739,402666,936130,773448,840577,584645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]