SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002838s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489095 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489095 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774094,911142,740787,178503,291659,90140,702011,203848,452611,94090,271955,889175,395485,295805,280736,345545,831994,426193,307235,989878,734898,328991,922910,371332,165362,847422,624228,459154,312574,947714,1005897,424069,811251,889322,504063,826757,225347,484805,562711,278692,375640,608990,198773,772003,394214,937330,729936,839017,707369,688608,636995,1019164,940294,432574,932397,746075,407165,389508,580102,868013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]